SELECT Id FROM new_searchtable
where (town like 'Lyme' or town like 'Enfield' or town like 'Plainfield' or town like 'Cornish') and (type = 'R' or type ='O')
AND list_price BETWEEN '500000' AND '1000000'
ORDER BY list_price Desc
Upper Valley NH Homes page 5
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:If you are looking for a home that has a country feel, with a scenic country road access, yet offers Windsor VT, Claremont and the Upper Valley of NH, all within a 25 minute drive or less, this location will speak to you. This is a custom built home, that has hillside views (can be improved with some clearing), a brook at the north end of the property, a detached 2 car garage (2016), standby generator, privacy and gardens. Inside you have large spaces, vaulted ceilings, wood beams, a kitchen with a view and granite counters. The stone fireplace goes two stories high. In some houses that would be the focal point, this home offers several. The sunroom, it is sunny and bright, take in the view and stay warm with the gas fireplace. Step out onto the deck and take in the fresh air. The primary suite is large, has direct access to the deck and a bath that is just a dream. There is space for a in-home gym and office. The second floor has an open loft, two large bedrooms and full bath. Radiant heat on the main floor keeps you warm all winter and the newer metal roof gives you peace of mind. Other features: hardwood floors, paved driveway, pellet stove, water filtration, dumbwaiter and more! Delayed showings, showings start at the open house on Saturday 09/07 11am-1pm
Description:CUSTOM BUILT!! This almost new Colonial offers an abundance of space. The main house includes 4 bedrooms, 2 1/2 baths, and an accessory dwelling unit with a separate entrance, parking, laundry, and 1 bedroom, 1 bath at the lower level. Also included is a very spacious 3 bay attached garage with work space area; office, 1/2 bath, and storage above! Outside includes a beautiful covered porch with an abundance of perennials on the front side; and a deck to enjoy the country and wildlife in privacy! Accessory dwelling conveying fully furnished. Invisible pet fence outside as well! All this on 10+ acres on the VAST trail! No showings until 10/5. Open house 10/5 12-2pm.
Description:Discover timeless charm in this 1820 brick farmhouse nestled on 90 acres of picturesque landscape, with westerly views spanning both sides of Middle Road in Plainfield. Blending historic elegance and modern comfort. The front of the residence showcases sturdy brick construction, while a wood frame el extends to the rear. Inside, classic details abound, with exposed beams, rich wood flooring, and two inviting fireplaces in the living room and dining area. High ceilings accentuate the sense of space and openness throughout. A first-floor bedroom, 3/4 bathroom, and laundry facilities offer the option of effortless single-level living. Upstairs, find two bedrooms with a full bathroom and an expansive studio boasting a cathedral ceiling and skylights. The private, expansive deck off the den, provides the perfect retreat for relaxation or entertaining, with a portion thoughtfully covered for year-round enjoyment. Across the street, a post and beam barn stands as a testament to the property's rich heritage, offering versatile storage space or animal accommodations with some updates. A solar array on-site, ensures minimal electric bills for the next owner. This property is further enhanced by its composition of approximately half open land and half wooded, all enrolled in Vermont's Current Use Program, presenting both aesthetic beauty and practical benefits. Cherished by the current owner since 1972, this home and its expansive grounds epitomize a lifetime of love and stewardship.
Description:Fantastic Mascoma Lake property with 93' of water frontage and breathtaking views of the surrounding mountains. The open layout connects a spacious kitchen, dining area, and family room with an adjacent screened-in seasonal porch to take in your dock, boat, and the expanse of the lake beyond. The interiors have recently been substantially renovated and upgraded, with a floor plan flow that accentuates the water view. There are three bedrooms upstairs, one of which is a primary suite overlooking the lake, while an office on the first floor could easily be converted into an additional bedroom. Stay warm in the winter with the pellet stove and radiant heat throughout. With so much fun on the lake leaving will be challenging, but when you do I-89 is nearby, making the rest of the Upper Valley readily accessible.
Description:Located on a rise overlooking the pastoral gateway that extends east to the village of Lyme and west towards the Connecticut River is this iconic brick cape, built and continuously owned by the famous Grant family since 1799. Now for the first time in 200+ years, this very special historic homestead is being offered for sale on 24.03+/- acres. The house requires restoration but with its high ceilings, comfortable floor plan, updated double-hung windows, full basement, new roof, and furnace, it has great bones to work with. The back wing also has potential and character worth updating, but the attached post and beam barn, with lovely old beams and barn boards, needs to be taken down, salvaged and or replaced. Outside, the land is mostly comprised of fields. Directly west of the house is a large level area with fertile soils where the Grant’s used to have a prolific vegetable garden. Further below, on the 20-acre portion that is conserved with the Upper Valley Land Trust, another field slopes down to the brook, then west. Most of the acreage is suitable for livestock. The Grant Brook Trail crosses the property and leads from the village of Lyme to the Connecticut River. Across the street is an extensive network of groomed XC ski trails. Last but not least, several abutting parcels and others within view of the house are conserved thus ensuring that the beauty of this undeveloped area will remain in perpetuity.